How to import data from excel to datatable in c#

Question

lethl marc · Answer

and and and and and and and and and and and and and and and  MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\yourfile.xls';Extended Properties=Excel 8.0;");and and and and and and and and and and and and and and and  MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);and and and and and and and and and and and and and and and  MyCommand.TableMappings.Add("Table", "TestTable");and and and and and and and and and and and and and and and  DtSet = new System.Data.DataSet();and and and and and and and and and and and and and and and  MyCommand.Fill(DtSet);Lethaland and and

Sebastien Morin · Answer

Thank you very much for your solution. For future reference, I've modified your code to ensure object disposal:

System.Data.DataTable dtExcel = new System.Data.DataTable();
dtExcel.TableName = "MyExcelData";
string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='MyExcelFilePath';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
using (OleDbConnection con = new OleDbConnection(SourceConstr))
using (OleDbDataAdapter data = new OleDbDataAdapter("Select * from [Sheet1$]", con))
{
data.Fill(dtExcel);
}

anver sadat · Answer

Dear arun,and and and and and and and and and and and and  thnx for sharing your code, it saved my lots of time.i was getting error when application was deployed on server.htnx

Laila prog · Answer

Hello,
I want to import data from an Excel file into a database SQL Server 2008, the Excel file contains multiple sheets, each sheet represents a table row e in the database, and I must also respect the constraints intergrités, if you can offer me a code that does almost the same thing THANKS

Anonymous User · Answer

Hello Pravesh Singh,
Check this code...
System.Data.DataTable
dtExcel = new System.Data.DataTable();dtExcel.TableName = "MyExcelData";string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source='MyExcelFilePath';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";OleDbConnection con = new OleDbConnection(SourceConstr);string query = "Select
* from [Sheet1$]";OleDbDataAdapter data = new OleDbDataAdapter(query,
con);data.Fill(dtExcel);
It might be resolve your problem.

forum

How to import data from excel to datatable in c#

Pravesh Singh

Can you answer this question?

5 Answers

Liked By